﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="addResult.aspx.vb" Inherits="soccer.addResult" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
    <style type="text/css">
        .auto-style1 {
            font-size: medium;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="FeaturedContent" runat="server">
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="MainContent" runat="server">
    <p>
       &nbsp;</p>
    <p>
        <span class="auto-style1">Share your soccer result here !</span><asp:SqlDataSource ID="SoccerDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:SoccerConnectionString %>" ProviderName="<%$ ConnectionStrings:SoccerConnectionString.ProviderName %>" SelectCommand="SELECT * FROM [Division]"></asp:SqlDataSource>
    </p>
    <p>
      Division&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        <asp:DropDownList ID="dd_Division" runat="server" DataSourceID="SoccerDataSource" DataTextField="divisionName" DataValueField="DivisionId" Height="36px" Width="305px">
        </asp:DropDownList>
    </p>
    <p>
      Home Team&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <asp:DropDownList ID="dd_HomeTeam" runat="server" DataSourceID="TeamDataSource" DataTextField="teamName" DataValueField="teamID" Height="36px" Width="305px">
        </asp:DropDownList>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; HomeTeam Score&nbsp; <asp:TextBox ID="tb_HomeTeamScore" runat="server"></asp:TextBox>
&nbsp;<asp:SqlDataSource ID="TeamDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:SoccerConnectionString %>" ProviderName="<%$ ConnectionStrings:SoccerConnectionString.ProviderName %>" SelectCommand="SELECT * FROM [Team] WHERE ([divisionId] = ?)">
            <SelectParameters>
                <asp:ControlParameter ControlID="dd_Division" Name="divisionId" PropertyName="SelectedValue" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
    &nbsp;</p>
    <p>
      &nbsp;Away Team&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  
        <asp:DropDownList ID="dd_AwayTeam" runat="server" DataSourceID="TeamDataSource" DataTextField="teamName" DataValueField="teamID" Height="36px" Width="307px">
        </asp:DropDownList>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Away Team Score&nbsp;&nbsp; <asp:TextBox ID="tb_AwayTeamScore" runat="server"></asp:TextBox>
    </p>
    <p>
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
      Fixture Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  <asp:TextBox ID="tb_FixtureDate" runat="server"></asp:TextBox>
    &nbsp;&nbsp;&nbsp;&nbsp;
        <asp:Calendar ID="Calendar1" runat="server"></asp:Calendar>
    </p>
    <p>
      Venue&nbsp;
        <asp:DropDownList ID="dd_venueId" runat="server" DataSourceID="VenueDataSource" DataTextField="venueName" DataValueField="venueId" Height="36px" Width="241px">
        </asp:DropDownList>
        <asp:SqlDataSource ID="VenueDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:SoccerConnectionString %>" ProviderName="<%$ ConnectionStrings:SoccerConnectionString.ProviderName %>" SelectCommand="SELECT Venue.venueID, Town.townName, Venue.venueName FROM (Venue INNER JOIN Town ON Venue.TownId = Town.townID) ORDER BY Venue.venueName"></asp:SqlDataSource>
    </p>
    <p>
      Match Photo  
        <asp:FileUpload ID="F_Picture" runat="server" />
    </p>
    <p>
      Referee  <asp:TextBox ID="tb_Referee" runat="server"></asp:TextBox>
    </p>
    <p>
        <asp:Button ID="btn_SubmitResult" runat="server" Text="Submit this result" />
        <br />
    </p>
</asp:Content>
